SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for jb_application
-- ----------------------------
DROP TABLE IF EXISTS `jb_application`;
CREATE TABLE `jb_application`
(
    `id`              bigint                                                        NOT NULL COMMENT '主键ID',
    `name`            varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '应用名称',
    `brief_info`      varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '应用简介',
    `app_id`          varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '应用ID',
    `app_secret`      varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '应用密钥',
    `enable`          char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否启用',
    `create_time`     datetime                                                               DEFAULT NULL COMMENT '创建时间',
    `update_time`     datetime                                                               DEFAULT NULL COMMENT '更新时间',
    `user_id`         bigint                                                                 DEFAULT NULL COMMENT '创建用户ID',
    `update_user_id`  bigint                                                                 DEFAULT NULL COMMENT '更新用户ID',
    `type`            int                                                           NOT NULL COMMENT 'app类型',
    `need_check_sign` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否需要接口校验SIGN',
    `is_inner`        char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否需要接口校验SIGN',
    `link_target_id`  bigint                                                                 DEFAULT NULL COMMENT '关联目标ID',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='API应用中心的应用APP';

-- ----------------------------
-- Table structure for jb_code_gen
-- ----------------------------
DROP TABLE IF EXISTS `jb_code_gen`;
CREATE TABLE `jb_code_gen`
(
    `id`                                          bigint                                                        NOT NULL COMMENT '主键ID',
    `pid`                                         bigint                                                                 DEFAULT '0' COMMENT '父ID',
    `project_path`                                varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '项目根路径',
    `project_module`                              varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '项目模块',
    `is_sub_table`                                char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否为子表',
    `sort_rank`                                   int                                                           NOT NULL DEFAULT '1' COMMENT '子表的顺序',
    `type`                                        varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '模块类型',
    `main_table_name`                             varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主表名',
    `datasource_name`                             varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '数据源',
    `datasource_remark`                           varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '数据源说明',
    `database_type`                               varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '数据库类型',
    `is_main_datasource`                          char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否为主数据源',
    `main_table_pkey`                             varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT 'id' COMMENT '主表主键',
    `table_remove_prefix`                         varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '数据表删除前缀',
    `main_table_idgenmode`                        varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '主表主键策略',
    `version_sn`                                  int                                                           NOT NULL COMMENT '版本序号',
    `main_table_remark`                           varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '表备注',
    `author`                                      varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '功能作者',
    `is_crud`                                     char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否CRUD',
    `is_editable`                                 char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否可编辑表格',
    `is_tree_table`                               char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否为树表',
    `is_check_can_delete`                         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '检测是否可以刪除数据',
    `is_check_can_toggle`                         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '检测是否可以toggle数据',
    `is_check_can_recover`                        char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '检测是否可以recover数据',
    `editable_submit_type`                        varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '可编辑提交方式',
    `state`                                       int                                                           NOT NULL COMMENT '生成状态',
    `topnav_id`                                   bigint                                                                 DEFAULT NULL COMMENT '顶部导航',
    `permission_id`                               bigint                                                                 DEFAULT NULL COMMENT '关联权限',
    `roles`                                       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '可访问角色',
    `create_time`                                 datetime                                                      NOT NULL COMMENT '创建时间',
    `update_time`                                 datetime                                                      NOT NULL COMMENT '更新时间',
    `gen_time`                                    datetime                                                               DEFAULT NULL COMMENT '创建后执行生成时间',
    `model_name`                                  varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT 'modelName',
    `base_model_name`                             varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT 'baseModelName',
    `remark`                                      varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '备注',
    `is_auto_cache`                               char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否启用autoCache',
    `is_id_cache`                                 char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否启用idCache',
    `is_key_cache`                                char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否启用keyCache',
    `key_cache_column`                            varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT 'keyCache指定Column',
    `key_cache_bind_column`                       varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT 'keyCache指定bindColumn',
    `controller_name`                             varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Controller Name',
    `controller_path`                             varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'controller path',
    `main_java_package`                           varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'java主包pacakge',
    `service_name`                                varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Service Name',
    `controller_package`                          varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Controller代码包',
    `service_package`                             varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Service代码包',
    `index_html_page_icon`                        varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT 'index.html标题icon',
    `index_html_page_title`                       varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT 'index.html页面标题',
    `model_package`                               varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT 'model 所属package',
    `html_view_path`                              varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT 'html view path',
    `routes_scan_package`                         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '路由扫描包',
    `is_gen_model`                                char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '是否需要生成Model',
    `is_table_use_record`                         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '表格是否使用record',
    `is_table_record_camel_case`                  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '表格列名用驼峰的attrName',
    `is_import_excel`                             char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否支持Excel导入',
    `is_export_excel`                             char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否支持Excel导出',
    `is_export_excel_by_checked_ids`              char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否启用 导出选中行功能',
    `is_export_excel_by_form`                     char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '是否启用导出表单查询结果功能',
    `is_export_excel_all`                         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否启用导出所有数据',
    `is_copy_to_excel`                            char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否支持表格复制到excel',
    `is_copy_from_excel`                          char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否支持从excel复制到可编辑表格',
    `is_toolbar`                                  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否使用toolbar模式',
    `is_headbox`                                  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否使用headbox',
    `is_leftbox`                                  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否使用leftBox',
    `is_rightbox`                                 char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否使用rightBox',
    `is_footbox`                                  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否使用footbox',
    `is_paginate`                                 char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '是否分页查询',
    `is_table_sortable_move`                      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否开启移动排序功能',
    `leftbox_width`                               int                                                                    DEFAULT '220' COMMENT 'leftbox width',
    `rightbox_width`                              int                                                                    DEFAULT '220' COMMENT 'right width',
    `headbox_height`                              int                                                                    DEFAULT '60' COMMENT 'headbox height',
    `footbox_height`                              int                                                                    DEFAULT '220' COMMENT 'footbox height',
    `is_leftbox_footer`                           char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '是否启用leftbox的footer',
    `is_rightbox_footer`                          char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '是否启用rightbox的footer',
    `leftbox_footer_button_count`                 int                                                                    DEFAULT NULL COMMENT 'leftbox footer button count',
    `rightbox_footer_button_count`                int                                                                    DEFAULT NULL COMMENT 'rightbox footer button count',
    `leftbox_title`                               varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT 'leftbox' COMMENT 'leftbox title',
    `leftbox_icon`                                varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT 'fa fa-cog' COMMENT 'leftbox icon',
    `rightbox_title`                              varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT 'rightbox' COMMENT 'rightbox title',
    `rightbox_icon`                               varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT 'fa fa-cog' COMMENT 'rightbox icon',
    `is_show_optcol_sort`                         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否开启操作列排序功能',
    `is_show_optcol_edit`                         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否开启操作列显示编辑按钮',
    `is_show_optcol_del`                          char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否开启操作列显示删除按钮',
    `is_show_optcol`                              char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '是否显示操作列',
    `is_show_optcol_recover`                      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否显示操作列的恢复按钮',
    `default_sort_column`                         varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '默认排序字段',
    `default_sort_type`                           varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '默认排序方式',
    `table_optcol_width`                          int                                                           NOT NULL DEFAULT '80' COMMENT '长度',
    `is_table_column_resize`                      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '表格是否开启调整列宽功能',
    `is_table_prepend_column`                     char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否增加填充列',
    `table_prepend_column_type`                   varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '表格chechbox radio配置类型',
    `table_prepend_column_index`                  int                                                           NOT NULL DEFAULT '1' COMMENT '填充列到第几列',
    `is_table_prepend_column_linkparent`          char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '填充列linkparent',
    `is_table_prepend_column_linkson`             char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '填充列linkson',
    `table_prepend_column_rowspan`                int                                                           NOT NULL DEFAULT '1' COMMENT '填充列表头是几行rowspan',
    `is_table_prepend_column_click_active`        char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否点击行就切换列填充组件选中状态',
    `table_fixed_column_left`                     varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '左侧固定列',
    `table_fixed_column_right`                    varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '右侧固定列',
    `table_pagesize_options`                      varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '分页pagesize自定义设置',
    `table_width_assign`                          varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '表格宽度自定义值',
    `table_width`                                 varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL DEFAULT 'fill' COMMENT '表格宽度',
    `table_height_assign`                         varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '表格高度自定义值',
    `table_height`                                varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL DEFAULT 'fill' COMMENT '表格高度',
    `table_default_sort_column`                   varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT 'id' COMMENT '表格默认排序字段',
    `table_default_sort_type`                     varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT 'desc' COMMENT '表格默认排序类型',
    `is_keywords_search`                          char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '是否开启关键词查询',
    `keywords_match_columns`                      varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '关键词匹配列',
    `toolbar_extra_button_size`                   int                                                                    DEFAULT NULL COMMENT 'toolbar 额外预留按钮个数',
    `is_deleted`                                  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '删除标识',
    `form_column_size`                            int                                                           NOT NULL DEFAULT '1' COMMENT '表单分几列',
    `is_form_group_row`                           char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '表单form-group风格 左右还是上下',
    `form_column_proportion`                      varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '表单分多列 比例值',
    `form_column_direction`                       varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT 'v' COMMENT '表单列排布方向 横向还是纵向',
    `form_group_proportion`                       varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT '2:10' COMMENT 'form-group row状态下的比例',
    `is_view_use_path`                            char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '是否启用Path注解路由',
    `view_layout`                                 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '使用布局器',
    `is_need_new_route`                           char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否需要创建新的路由配置类',
    `routes_class_name`                           varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '哪个路由配置类',
    `is_need_admin_interceptor`                   char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '是否需要后台管理权限拦截器',
    `extra_interceptor_class_name`                varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '额外配置的拦截器',
    `is_table_multi_conditions_mode`              char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '表格查询条件是否启用高级多条件模式',
    `is_table_multi_conditions_default_hide`      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '表格查询高级模式 是否隐藏条件 默认隐藏',
    `is_table_multi_conditions_btn_show_title`    char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '表格高级查询条件切换按钮是否显示标题',
    `is_toolbar_add_btn`                          char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '表格toolbar上启用添加按钮',
    `is_toolbar_edit_btn`                         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '表格toolbar上启用编辑按钮',
    `is_toolbar_del_btn`                          char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '表格toolbar上启用删除按钮',
    `is_toolbar_recover_btn`                      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '表格toolbar上启用恢复按钮 当有is_deleted时',
    `is_toolbar_refresh_btn`                      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '表格tolbar上启用刷新按钮',
    `is_page_title_add_btn`                       char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '是否启用pageTitle上的添加按钮',
    `is_page_title_refresh_btn`                   char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '是否启用pageTitle上的刷新按钮',
    `is_page_title_init_rank_btn`                 char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否启用pageTitle上的初始化顺序按钮',
    `is_project_system_log`                       char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否启用systemLog日志',
    `project_system_log_target_type_text`         varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '系统日志text',
    `project_system_log_target_type_value`        varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '系统日志value值',
    `project_system_log_target_type_key_name`     varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '系统日志KeyName',
    `form_dialog_area`                            varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT '800,600' COMMENT 'form表单的dialog的area属性 长宽',
    `is_base_model_gen_col_constant`              char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '是否在baseModel中生成字段常量',
    `is_base_model_gen_col_constant_to_uppercase` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '是否在baseModel中生成的字段常量 名称转大写',
    `thead_bg_color`                              varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '表头背景色',
    `thead_fr_color`                              varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '表头文字颜色',
    `is_table_row_click_active`                   char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否表格选中定色',
    `active_tr_bg_color`                          varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '选中行背景色',
    `active_tr_fr_color`                          varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '选中行文字颜色',
    `is_gen_cache_util_class`                     char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否生成缓存工具类',
    `cache_class_name`                            varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '缓存工具类名',
    `cache_class_package`                         varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '缓存工具类包',
    `is_cache_get_name`                           char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否生成getName',
    `is_cache_get_sn`                             char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否生成getSn',
    `is_cache_get_name_by_sn`                     char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否生成getNameBySn(sn)',
    `is_cache_get_by_sn`                          char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否生成getBySn(sn)',
    `model_title`                                 varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '模型名称',
    `is_gen_options_action`                       char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否生成options接口',
    `is_return_option_type`                       char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci               DEFAULT '1' COMMENT '是否返回Option类型',
    `options_text_column`                         varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT 'name' COMMENT 'options接口text用哪一列',
    `options_value_column`                        varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT 'id' COMMENT 'options接口value用哪一列',
    `is_gen_autocomplete_action`                  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否生成Autocomplete接口',
    `autocomplete_limit`                          int                                                           NOT NULL DEFAULT '20' COMMENT 'autocomplete接口limit',
    `autocomplete_match_columns`                  varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT 'autocomplete接口匹配字段',
    `pagesize`                                    int                                                           NOT NULL DEFAULT '15' COMMENT '分页大小',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='代码生成配置';

-- ----------------------------
-- Table structure for jb_code_gen_model_attr
-- ----------------------------
DROP TABLE IF EXISTS `jb_code_gen_model_attr`;
CREATE TABLE `jb_code_gen_model_attr`
(
    `id`                                  bigint                                                       NOT NULL COMMENT '主键ID',
    `code_gen_id`                         bigint                                                       NOT NULL COMMENT '所属codeGen',
    `col_name`                            varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '列名',
    `attr_name`                           varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '属性名',
    `java_type`                           varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '属性类型',
    `attr_length`                         int                                                          NOT NULL DEFAULT '20' COMMENT '属性长度',
    `attr_fixed`                          int                                                                   DEFAULT '0' COMMENT '属性小数点',
    `attr_default_value`                  varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '默认值',
    `sort_rank`                           int                                                          NOT NULL DEFAULT '1' COMMENT '数据表内默认顺序',
    `sort_rank_intable`                   int                                                          NOT NULL DEFAULT '1' COMMENT '表格中的排序',
    `sort_rank_inform`                    int                                                          NOT NULL DEFAULT '1' COMMENT '表单中的排序',
    `sort_rank_insearch`                  int                                                          NOT NULL DEFAULT '1' COMMENT '查询条件中的顺序',
    `is_pkey`                             char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否主键',
    `is_required`                         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否必填',
    `is_search_required`                  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '作为查询条件是否必填',
    `data_rule_for_search`                varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '查询条件必填校验规则',
    `data_tips_for_search`                varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '查询条件不符合校验的提示信息',
    `form_label`                          varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '表单单显示文本',
    `placeholder`                         varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '表单placeholder',
    `table_label`                         varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '表格中显示文本',
    `search_form_label`                   varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '查询表单提示文本',
    `remark`                              varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '备注',
    `is_keywords_column`                  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否为关键词查询列',
    `is_form_ele`                         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '1' COMMENT '是否表单可编辑元素',
    `is_table_col`                        char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '1' COMMENT '是否表格列',
    `is_table_switchbtn`                  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否为表格switchbtn',
    `table_col_width`                     int                                                          NOT NULL DEFAULT '100' COMMENT '列宽',
    `is_need_fixed_width`                 char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '1' COMMENT '是否固定宽度',
    `is_search_ele`                       char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否检索条件',
    `is_search_hidden`                    char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否为检索隐藏条件',
    `col_format`                          varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '格式化操作值',
    `search_ui_type`                      varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '查询用ui 组件类型',
    `search_data_type`                    varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '查询用组件数据源类型',
    `search_data_value`                   varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '查询用组件数据值',
    `search_default_value`                varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '查询用组件默认值',
    `is_single_line`                      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '独立新行',
    `need_data_handler`                   char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci              DEFAULT NULL COMMENT '是否需要data_handler',
    `form_ui_type`                        varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '表单组件类型',
    `form_jboltinput_filter_handler`      varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT 'jboltinput filter handler',
    `is_form_jboltinput_jstree_checkbox`  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci              DEFAULT '0' COMMENT 'jboltinput jstree是否有checkbox',
    `is_form_jboltinput_jstree_only_leaf` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci              DEFAULT NULL COMMENT 'jboltinput jstree checkbox只选子节点',
    `form_data_type`                      varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '表单组件数据源类型',
    `form_data_value`                     varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '表单组件数据值',
    `form_default_value`                  varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '表单组件默认值',
    `data_rule_assign`                    varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '表单校验规则 自定义',
    `data_rule`                           varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '校验规则',
    `data_tips`                           varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '校验提示信息',
    `is_import_col`                       char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否为导入列',
    `is_export_col`                       char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '导出列',
    `is_sortable`                         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否可排序',
    `table_ui_type`                       varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '可编辑表格显示组件类型',
    `table_data_type`                     varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '表格组件数据库类型',
    `table_data_value`                    varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '表格组件数据值',
    `form_ele_width`                      int                                                          NOT NULL DEFAULT '0' COMMENT '组件自定义宽度',
    `is_item_inline`                      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '1' COMMENT 'radio checkbox等是否inline',
    `form_data_text_attr`                 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT 'data-text-attr',
    `form_data_value_attr`                varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT 'data-value-attr',
    `form_data_column_attr`               varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT 'data-column-attr',
    `search_data_text_attr`               varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT 'data-text-attr',
    `search_data_value_attr`              varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT 'data-value-attr',
    `search_data_column_attr`             varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT 'data-column-attr',
    `table_data_text_attr`                varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT 'data-text-attr',
    `table_data_value_attr`               varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT 'data-value-attr',
    `table_data_column_attr`              varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT 'data-column-attr',
    `is_need_translate`                   char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否需要翻译',
    `translate_type`                      varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '翻译类型',
    `translate_use_value`                 varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '翻译用值',
    `translate_col_name`                  varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '翻译后的列名',
    `is_upload_to_qiniu`                  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否上传到七牛',
    `form_upload_url`                     varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '上传地址',
    `form_img_uploader_area`              varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT '200,200' COMMENT '上传组件area',
    `form_maxsize`                        int                                                                   DEFAULT '200' COMMENT '上传尺寸限制',
    `qiniu_bucket_sn`                     varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '七牛bucket sn',
    `qiniu_file_key`                      varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT '[dateTime]/[randomId]/[filename]' COMMENT '七牛file key',
    `is_need_check_exists`                char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否检测数据重复字段',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='CodeGen模型详细设计';

-- ----------------------------
-- Table structure for jb_datasource_filter
-- ----------------------------
DROP TABLE IF EXISTS `jb_datasource_filter`;
CREATE TABLE `jb_datasource_filter`
(
    `id`                  bigint                                                        NOT NULL COMMENT '主键ID',
    `name`                varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
    `config_name`         varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置名称',
    `table_name_filter`   text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '不需要生成的表名',
    `table_name_contains` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '需要排除包含字符',
    `table_name_patterns` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '需要排除符合正则的',
    `create_user_id`      bigint                                                        NOT NULL COMMENT '创建人',
    `update_user_id`      bigint                                                        NOT NULL COMMENT '更新人',
    `create_time`         datetime                                                      NOT NULL COMMENT '创建时间',
    `update_time`         datetime                                                      NOT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='数据源过滤配置';

-- ----------------------------
-- Table structure for jb_dept
-- ----------------------------
DROP TABLE IF EXISTS `jb_dept`;
CREATE TABLE `jb_dept`
(
    `id`          bigint                                                       NOT NULL COMMENT '主键ID',
    `name`        varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
    `full_name`   varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '全称',
    `pid`         bigint                                                                DEFAULT NULL COMMENT '父级ID',
    `dept_path`   varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '部门路径',
    `type`        varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型',
    `leader`      varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '负责人',
    `phone`       varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '联系电话',
    `email`       varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '电子邮箱',
    `address`     varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '联系地址',
    `zipcode`     varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '邮政编码',
    `remark`      varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '备注信息',
    `sort_rank`   int                                                                   DEFAULT NULL COMMENT '顺序',
    `sn`          varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '机构代码',
    `enable`      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '1' COMMENT '启用/禁用',
    `update_time` datetime                                                              DEFAULT NULL COMMENT '最后更新时间',
    `create_time` datetime                                                              DEFAULT NULL COMMENT '创建时间',
    `has_son`     char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '存在子部门',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='组织机构';

-- ----------------------------
-- Table structure for jb_dictionary
-- ----------------------------
DROP TABLE IF EXISTS `jb_dictionary`;
CREATE TABLE `jb_dictionary`
(
    `id`          bigint                                                        NOT NULL COMMENT '字典ID主键',
    `name`        varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
    `type_id`     bigint                                                        NOT NULL COMMENT '字典类型ID',
    `pid`         bigint                                                                 DEFAULT NULL COMMENT '父类ID',
    `sort_rank`   int                                                           NOT NULL DEFAULT '1' COMMENT '排序',
    `sn`          varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编号编码',
    `type_key`    varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '字典类型KEY',
    `enable`      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '是否启用',
    `is_build_in` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否内置',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='字典表';

-- ----------------------------
-- Table structure for jb_dictionary_type
-- ----------------------------
DROP TABLE IF EXISTS `jb_dictionary_type`;
CREATE TABLE `jb_dictionary_type`
(
    `id`          bigint                                                   NOT NULL COMMENT '主键ID',
    `name`        varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL,
    `mode_level`  int                                                               DEFAULT NULL COMMENT '模式层级',
    `type_key`    varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '标识KEY',
    `enable`      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1' COMMENT '是否启用',
    `is_build_in` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否内置',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='字典类型';

-- ----------------------------
-- Table structure for jb_global_config
-- ----------------------------
DROP TABLE IF EXISTS `jb_global_config`;
CREATE TABLE `jb_global_config`
(
    `id`             bigint                                                        NOT NULL COMMENT '主键ID',
    `config_key`     varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置KEY',
    `config_value`   text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '配置项值',
    `create_time`    datetime                                                      NOT NULL COMMENT '创建时间',
    `user_id`        bigint                                                        DEFAULT NULL COMMENT '创建用户ID',
    `update_time`    datetime                                                      DEFAULT NULL COMMENT '更新时间',
    `update_user_id` bigint                                                        DEFAULT NULL COMMENT '更新用户ID',
    `name`           varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
    `value_type`     varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '值类型',
    `type_key`       varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '类型key',
    `type_id`        bigint                                                        DEFAULT NULL COMMENT '类型ID',
    `built_in`       char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT '0' COMMENT '内置参数',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='全局配置';

-- ----------------------------
-- Table structure for jb_global_config_type
-- ----------------------------
DROP TABLE IF EXISTS `jb_global_config_type`;
CREATE TABLE `jb_global_config_type`
(
    `id`        bigint                                                       NOT NULL COMMENT '主键ID',
    `name`      varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型名称',
    `sort_rank` int                                                      DEFAULT NULL COMMENT '序号',
    `type_key`  varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类型KEY',
    `built_in`  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '内置',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT ='全局参数类型分组';

-- ----------------------------
-- Table structure for jb_jbolt_file
-- ----------------------------
DROP TABLE IF EXISTS `jb_jbolt_file`;
CREATE TABLE `jb_jbolt_file`
(
    `id`          bigint NOT NULL COMMENT '主键ID',
    `local_path`  varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '保存物理地址',
    `local_url`   varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '本地可访问URL地址',
    `create_time` datetime                                                      DEFAULT NULL COMMENT '创建时间',
    `user_id`     bigint                                                        DEFAULT NULL COMMENT '用户ID',
    `file_name`   varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '文件名',
    `file_type`   int                                                           DEFAULT NULL COMMENT '文件类型 图片 附件 视频 音频',
    `file_size`   int                                                           DEFAULT '0' COMMENT '文件大小',
    `file_suffix` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '后缀名',
    `link_id`     bigint                                                        DEFAULT NULL COMMENT '关联ID',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='文件库';

-- ----------------------------
-- Table structure for jb_login_log
-- ----------------------------
DROP TABLE IF EXISTS `jb_login_log`;
CREATE TABLE `jb_login_log`
(
    `id`                      bigint                                                       NOT NULL COMMENT '主键ID',
    `user_id`                 bigint                                                                DEFAULT NULL COMMENT '用户ID',
    `username`                varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
    `login_ip`                varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT 'IP地址',
    `login_time`              datetime                                                     NOT NULL COMMENT '登录时间',
    `login_state`             int                                                          NOT NULL COMMENT '登录状态',
    `is_browser`              char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否是浏览器访问',
    `browser_version`         varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '浏览器版本号',
    `browser_name`            varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '浏览器',
    `os_name`                 varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '操作系统',
    `login_city`              varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '登录城市',
    `login_address`           varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '登录位置详情',
    `login_city_code`         varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '登录城市代码',
    `login_province`          varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '登录省份',
    `login_country`           varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '登录国家',
    `is_mobile`               char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否移动端',
    `os_platform_name`        varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '平台名称',
    `browser_engine_name`     varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '浏览器引擎名',
    `browser_engine_version`  varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '浏览器引擎版本',
    `login_address_latitude`  varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '登录地横坐标',
    `login_address_longitude` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '登录地纵坐标',
    `is_remote_login`         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否为异地异常登录',
    `create_time`             datetime                                                              DEFAULT NULL COMMENT '记录创建时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='登录日志';

-- ----------------------------
-- Table structure for jb_online_user
-- ----------------------------
DROP TABLE IF EXISTS `jb_online_user`;
CREATE TABLE `jb_online_user`
(
    `id`                bigint                                                         NOT NULL COMMENT '主键ID',
    `session_id`        varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '会话ID',
    `jbolt_jwt`         varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'jboltJwt',
    `jbolt_refresh_jwt` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'jboltRefreshJwt',
    `user_id`           bigint                                                         NOT NULL COMMENT '用户ID',
    `login_log_id`      bigint                                                         NOT NULL COMMENT '登录日志ID',
    `login_time`        datetime                                                                DEFAULT NULL COMMENT '登录时间',
    `update_time`       datetime                                                                DEFAULT NULL COMMENT '更新时间',
    `expiration_time`   datetime                                                       NOT NULL COMMENT '过期时间',
    `screen_locked`     char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci       NOT NULL DEFAULT '0' COMMENT '是否锁屏',
    `online_state`      int                                                            NOT NULL COMMENT '在线状态',
    `offline_time`      datetime                                                                DEFAULT NULL COMMENT '离线时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='在线用户';

-- ----------------------------
-- Table structure for jb_permission
-- ----------------------------
DROP TABLE IF EXISTS `jb_permission`;
CREATE TABLE `jb_permission`
(
    `id`                      bigint                                                       NOT NULL COMMENT '主键ID',
    `name`                    varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
    `pid`                     bigint                                                       NOT NULL DEFAULT '0' COMMENT '上级ID',
    `url`                     varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '地址',
    `icons`                   varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '图标',
    `sort_rank`               int                                                                   DEFAULT NULL COMMENT '排序',
    `permission_level`        int                                                                   DEFAULT NULL COMMENT '层级',
    `permission_key`          varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '权限资源KEY',
    `is_menu`                 char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否是菜单',
    `is_target_blank`         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否新窗口打开',
    `is_system_admin_default` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '0' COMMENT '是否系统超级管理员默认拥有的权限',
    `enable`                  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '1' COMMENT '是否启用',
    `open_type`               int                                                                   DEFAULT '1' COMMENT '打开类型 1 默认 2 iframe 3 dialog',
    `open_option`             varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         DEFAULT NULL COMMENT '组件属性json',
    `of_module`               int                                                          NOT NULL DEFAULT '1' COMMENT '哪个模块',
    `of_module_link`          varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '具体指向关联',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='function定义';


-- ----------------------------
-- Records of jb_permission
-- ----------------------------
BEGIN;
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163317067776, '系统管理', 0, NULL, 'carbon:cloud-service-management', 1, 1, 'systemmgr', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163321262080, '用户管理', 1680855163317067776, '/admin/user', 'ic:round-manage-accounts', 1, 2, 'user', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163329650688, '部门管理', 1680855163317067776, '/admin/dept', 'mingcute:department-fill', 2, 2, 'dept', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163333844992, '岗位管理', 1680855163317067776, '/admin/post', 'carbon:batch-job', 3, 2, 'post', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163342233600, '权限配置', 1680855163317067776, NULL, 'ic:baseline-security', 4, 2, 'role_permission_menu', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163346427904, '角色管理', 1680855163342233600, '/admin/role', 'carbon:user-role', 1, 3, 'role', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163359010816, '权限资源', 1680855163342233600, '/admin/permission', 'icon-park-outline:permissions', 2, 3, 'permission', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163363205120, '字典参数', 1680855163317067776, NULL, 'mdi:dictionary', 5, 2, 'dictionary_config', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163367399424, '数据字典', 1680855163363205120, '/admin/dictionary', 'fluent-mdl2:dictionary', 1, 3, 'dictionary', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163375788032, '全局参数', 1680855163363205120, '/admin/globalconfig', 'majesticons:data-line', 2, 3, 'globalconfig', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163379982336, '系统通知', 1680855163317067776, '/admin/sysnotice', 'ant-design:sound-outlined', 6, 2, 'sys_notice', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163384176640, '七牛配置', 1680855163317067776, NULL, 'icon-park:setting-config', 7, 2, 'qiniu_config', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163388370944, '七牛账号', 1680855163384176640, '/admin/qiniu', 'mdi:account-outline', 1, 3, 'qiniu', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163396759552, '七牛Bucket', 1680855163384176640, '/admin/qiniu/bucket', 'ph:paint-bucket-light', 2, 3, 'qiniu_bucket', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163400953856, '敏感词词库', 1680855163317067776, '/admin/sensitiveword', 'ooui:search-case-sensitive', 8, 2, 'sensitive_word', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163405148160, '系统监控', 0, NULL, 'ic:baseline-monitor', 2, 1, 'jbolt_monitor', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163409342464, 'Druid数据库监控', 1680855163405148160, 'http://localhost/admin/druid/monitor', 'material-symbols:database', 1, 2, 'druid_monitor', '1', '1', '1', '1', 5, '{\"urlWithToken\":true}', 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163417731072, '服务器监控', 1680855163405148160, '/admin/servermonitor', 'uil:server', 2, 2, 'jbolt_server_monitor', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163421925376, '日志监控', 1680855163405148160, NULL, 'octicon:log-24', 3, 2, 'jbolt_log_monitor', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163426119680, '登录日志', 1680855163421925376, '/admin/loginlog', 'icon-park-outline:log', 1, 3, 'jbolt_login_log', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163430313984, '关键操作日志', 1680855163421925376, '/admin/systemlog', 'ep:operation', 2, 3, 'systemlog', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163434508288, '在线用户', 1680855163405148160, '/admin/onlineuser', 'mdi:table-large', 4, 2, 'online_user', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163438702592, '开发平台', 0, NULL, 'game-icons:platform', 3, 1, 'dev_platform', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163447091200, '应用中心', 1680855163438702592, '/admin/app', 'icon-park-outline:more-app', 1, 2, 'application', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163451285504, '微信公众平台', 1680855163438702592, '/admin/wechat/mpinfo', 'ph:wechat-logo-duotone', 2, 2, 'wechat_mpinfo', '1', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163455479808, '基础配置', 1680855163451285504, NULL, NULL, 1, 3, 'wechat_config_basemgr', '0', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163459674112, '菜单配置', 1680855163451285504, NULL, NULL, 2, 3, 'wechat_menu', '0', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163463868416, '支付配置', 1680855163451285504, NULL, NULL, 3, 3, 'wechat_config_paymgr', '0', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163468062720, '关注回复', 1680855163451285504, NULL, NULL, 4, 3, 'wechat_autoreply_subscribe', '0', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163472257024, '关键词回复', 1680855163451285504, NULL, NULL, 5, 3, 'wechat_autoreply_keywords', '0', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163476451328, '默认回复', 1680855163451285504, NULL, NULL, 6, 3, 'wechat_autoreply_default', '0', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163480645632, '素材库', 1680855163451285504, NULL, NULL, 7, 3, 'wechat_media', '0', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163484839936, '用户管理', 1680855163451285504, NULL, NULL, 8, 3, 'wechat_user', '0', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1680855163489034240, '其它配置', 1680855163451285504, NULL, NULL, 9, 3, 'wechat_config_extramgr', '0', '0', '1', '1', 1, NULL, 1, NULL);
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1706136189922091008, '测试test', 0, '', 'simple-icons:speedtest', 4, 1, 'test', '1', '0', '1', '0', 1, NULL, 1, '1692957985218957312');
INSERT INTO `jb_permission` (`id`, `name`, `pid`, `url`, `icons`, `sort_rank`, `permission_level`, `permission_key`, `is_menu`, `is_target_blank`, `is_system_admin_default`, `enable`, `open_type`, `open_option`, `of_module`, `of_module_link`) VALUES (1706136387566084096, 'iframe打开druid监控', 1706136189922091008, 'http://localhost:9999/admin/druid/monitor', 'simple-icons:baidu', 1, 2, 'open_iframe', '1', '0', '1', '0', 2, '{\"urlWithToken\":true}', 1, '1692957985218957312');
COMMIT;

-- ----------------------------
-- Table structure for jb_post
-- ----------------------------
DROP TABLE IF EXISTS `jb_post`;
CREATE TABLE `jb_post`
(
    `id`        bigint                                                       NOT NULL COMMENT '主键ID',
    `name`      varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位名称',
    `type`      varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位类型',
    `sort_rank` int                                                           DEFAULT NULL COMMENT '顺序',
    `remark`    varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注信息',
    `sn`        varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编码',
    `enable`    char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT '1' COMMENT '启用/禁用',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT ='岗位';

-- ----------------------------
-- Table structure for jb_private_message
-- ----------------------------
DROP TABLE IF EXISTS `jb_private_message`;
CREATE TABLE `jb_private_message`
(
    `id`           bigint                                                NOT NULL COMMENT '主键ID',
    `content`      text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '私信内容',
    `create_time`  datetime                                              NOT NULL COMMENT '发送时间',
    `from_user_id` bigint                                                NOT NULL COMMENT '发信人',
    `to_user_id`   bigint                                                NOT NULL COMMENT '收信人',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT ='内部私信';

-- ----------------------------
-- Table structure for jb_qiniu
-- ----------------------------
DROP TABLE IF EXISTS `jb_qiniu`;
CREATE TABLE `jb_qiniu`
(
    `id`             bigint                                                        NOT NULL COMMENT '主键ID',
    `name`           varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '账号',
    `sn`             varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '编号SN',
    `ak`             varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT 'AK',
    `sk`             varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT 'SK',
    `type`           int                                                           NOT NULL COMMENT '账号类型',
    `bucket_count`   int                                                           NOT NULL DEFAULT '0' COMMENT '空间个数',
    `is_default`     char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否默认',
    `enable`         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否启用',
    `remark`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '备注',
    `create_time`    datetime                                                      NOT NULL COMMENT '创建时间',
    `update_time`    datetime                                                      NOT NULL COMMENT '更新时间',
    `create_user_id` bigint                                                        NOT NULL COMMENT '创建人',
    `update_user_id` bigint                                                        NOT NULL COMMENT '更新人',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='七牛账号表';

-- ----------------------------
-- Table structure for jb_qiniu_bucket
-- ----------------------------
DROP TABLE IF EXISTS `jb_qiniu_bucket`;
CREATE TABLE `jb_qiniu_bucket`
(
    `id`                 bigint                                                       NOT NULL COMMENT '主键ID',
    `name`               varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'bucket名称',
    `sn`                 varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编码',
    `qiniu_id`           bigint                                                       NOT NULL COMMENT '所属七牛账号',
    `domain_url`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '绑定域名',
    `callback_url`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '回调地址',
    `callback_body`      varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '回调body定义',
    `callback_body_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL COMMENT '回调Body类型',
    `expires`            int                                                           DEFAULT NULL COMMENT '有效期(秒)',
    `is_default`         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL COMMENT '是否默认',
    `enable`             char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL COMMENT '是否启用',
    `remark`             varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
    `create_user_id`     bigint                                                       NOT NULL COMMENT '创建人',
    `create_time`        datetime                                                     NOT NULL COMMENT '创建时间',
    `update_user_id`     bigint                                                       NOT NULL COMMENT '更新人',
    `update_time`        datetime                                                      DEFAULT NULL COMMENT '更新时间',
    `region`             varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '地区',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='七牛bucket配置';

-- ----------------------------
-- Table structure for jb_remote_login_log
-- ----------------------------
DROP TABLE IF EXISTS `jb_remote_login_log`;
CREATE TABLE `jb_remote_login_log`
(
    `id`                  bigint                                                   NOT NULL COMMENT '主键ID',
    `last_login_country`  varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '最近一次登录国家',
    `last_login_province` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '最近一次登录省份',
    `last_login_city`     varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '最近一次登录城市',
    `last_login_time`     datetime                                                          DEFAULT NULL COMMENT '最近一次登录时间',
    `login_country`       varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '新登录国家',
    `login_province`      varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '新登录省份',
    `login_city`          varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '新登录城市',
    `login_time`          datetime                                                          DEFAULT NULL COMMENT '新登录时间',
    `user_id`             bigint                                                            DEFAULT NULL COMMENT '登录用户ID',
    `username`            varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '登录用户名',
    `is_new`              char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否为最新一次',
    `last_login_ip`       varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '最近一次登录IP',
    `login_ip`            varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '新登录IP',
    `create_time`         datetime                                                          DEFAULT NULL COMMENT '记录创建时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='异地登录日志记录';

-- ----------------------------
-- Table structure for jb_role
-- ----------------------------
DROP TABLE IF EXISTS `jb_role`;
CREATE TABLE `jb_role`
(
    `id`   bigint                                                       NOT NULL COMMENT '主键ID',
    `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
    `sn`   varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '编码',
    `pid`  bigint                                                       DEFAULT '0' COMMENT '父级角色ID',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT ='角色表';

-- ----------------------------
-- Table structure for jb_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `jb_role_permission`;
CREATE TABLE `jb_role_permission`
(
    `id`            bigint NOT NULL COMMENT '主键ID',
    `role_id`       bigint NOT NULL COMMENT '角色ID',
    `permission_id` bigint NOT NULL COMMENT '权限ID',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='角色功能列表';

-- ----------------------------
-- Table structure for jb_sensitive_word
-- ----------------------------
DROP TABLE IF EXISTS `jb_sensitive_word`;
CREATE TABLE `jb_sensitive_word`
(
    `id`      bigint                                                       NOT NULL COMMENT '主键ID',
    `content` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '内容',
    `enable`  char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     NOT NULL DEFAULT '1' COMMENT '启用状态',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='敏感词词库';

-- ----------------------------
-- Table structure for jb_sys_notice
-- ----------------------------
DROP TABLE IF EXISTS `jb_sys_notice`;
CREATE TABLE `jb_sys_notice`
(
    `id`             bigint                                                        NOT NULL COMMENT '主键ID',
    `title`          varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
    `content`        text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         NOT NULL COMMENT '消息内容',
    `type`           int                                                           NOT NULL COMMENT '通知类型',
    `priority_level` int                                                           NOT NULL COMMENT '优先级',
    `read_count`     int                                                           DEFAULT '0' COMMENT '已读人数',
    `create_time`    datetime                                                      NOT NULL COMMENT '创建时间',
    `update_time`    datetime                                                      DEFAULT NULL COMMENT '更新时间',
    `create_user_id` bigint                                                        DEFAULT NULL COMMENT '创建人',
    `update_user_id` bigint                                                        DEFAULT NULL COMMENT '更新人',
    `receiver_type`  int                                                           DEFAULT NULL COMMENT '接收人类型',
    `receiver_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '接收人值',
    `files`          varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '附件',
    `is_deleted`     char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT '0' COMMENT '删除标志',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT ='系统通知';

-- ----------------------------
-- Table structure for jb_sys_notice_reader
-- ----------------------------
DROP TABLE IF EXISTS `jb_sys_notice_reader`;
CREATE TABLE `jb_sys_notice_reader`
(
    `id`            bigint   NOT NULL COMMENT '主键ID',
    `sys_notice_id` bigint   NOT NULL COMMENT '通知ID',
    `user_id`       bigint   NOT NULL COMMENT '用户ID',
    `create_time`   datetime NOT NULL COMMENT '创建时间',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT ='通知阅读用户关系表';

-- ----------------------------
-- Table structure for jb_system_log
-- ----------------------------
DROP TABLE IF EXISTS `jb_system_log`;
CREATE TABLE `jb_system_log`
(
    `id`          bigint NOT NULL COMMENT '主键ID',
    `title`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '标题',
    `type`        int                                                           DEFAULT NULL COMMENT '操作类型 删除 更新 新增',
    `url`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '连接对象详情地址',
    `user_id`     bigint                                                        DEFAULT NULL COMMENT '操作人ID',
    `user_name`   varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作人姓名',
    `target_type` int                                                           DEFAULT NULL COMMENT '操作对象类型',
    `create_time` datetime                                                      DEFAULT NULL COMMENT '记录创建时间',
    `target_id`   bigint                                                        DEFAULT NULL COMMENT '操作对象ID',
    `open_type`   int                                                           DEFAULT NULL COMMENT '打开类型URL还是Dialog',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='系统操作日志表';

-- ----------------------------
-- Table structure for jb_todo
-- ----------------------------
DROP TABLE IF EXISTS `jb_todo`;
CREATE TABLE `jb_todo`
(
    `id`                    bigint                                                        NOT NULL COMMENT '主键ID',
    `title`                 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
    `content`               text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '详情内容',
    `user_id`               bigint                                                        NOT NULL COMMENT '所属用户',
    `state`                 int                                                           NOT NULL COMMENT '状态',
    `specified_finish_time` datetime                                                      NOT NULL COMMENT '规定完成时间',
    `type`                  int                                                           NOT NULL COMMENT '类型 链接还是内容 还是都有',
    `url`                   varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '链接',
    `priority_level`        int                                                           NOT NULL COMMENT '优先级',
    `real_finish_time`      datetime                                                               DEFAULT NULL COMMENT '完成时间',
    `cancel_time`           datetime                                                               DEFAULT NULL COMMENT '取消时间',
    `create_user_id`        bigint                                                        NOT NULL COMMENT '创建人ID',
    `update_user_id`        bigint                                                                 DEFAULT NULL COMMENT '更新人ID',
    `create_time`           datetime                                                      NOT NULL COMMENT '创建时间',
    `update_time`           datetime                                                      NOT NULL COMMENT '更新时间',
    `source_msg_id`         varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '第三方系统消息主键',
    `source_request_id`     varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '第三方系统流程主键',
    `source_url`            varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '第三方url',
    `send_user_key`         varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '发送人第三方系统标识',
    `receive_user_key`      varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '接收人第三方系统标识',
    `source_sys`            varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '来源系统',
    `is_readed`             char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否已读',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT ='待办事项';

-- ----------------------------
-- Table structure for jb_topnav
-- ----------------------------
DROP TABLE IF EXISTS `jb_topnav`;
CREATE TABLE `jb_topnav`
(
    `id`        bigint NOT NULL COMMENT '主键ID',
    `name`      varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
    `icon`      varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图标',
    `enable`    char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT '0' COMMENT '是否启用',
    `sort_rank` int                                                          DEFAULT NULL COMMENT '排序',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT ='顶部导航';

-- ----------------------------
-- Table structure for jb_topnav_menu
-- ----------------------------
DROP TABLE IF EXISTS `jb_topnav_menu`;
CREATE TABLE `jb_topnav_menu`
(
    `id`            bigint NOT NULL COMMENT '主键ID',
    `topnav_id`     bigint DEFAULT NULL COMMENT '顶部导航ID',
    `permission_id` bigint DEFAULT NULL COMMENT '菜单资源ID',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT ='顶部菜单对应左侧一级导航中间表';

-- ----------------------------
-- Table structure for jb_user
-- ----------------------------
DROP TABLE IF EXISTS `jb_user`;
CREATE TABLE `jb_user`
(
    `id`                   bigint                                                        NOT NULL COMMENT '主键ID',
    `username`             varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '用户名',
    `password`             varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
    `name`                 varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '姓名',
    `sn`                   varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '工号',
    `avatar`               varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '头像',
    `create_time`          datetime                                                               DEFAULT NULL COMMENT '记录创建时间',
    `phone`                varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '手机号',
    `email`                varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '电子邮箱',
    `enable`               char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '启用',
    `sex`                  int                                                                    DEFAULT '0' COMMENT '性别',
    `age`                  int                                                                    DEFAULT '0' COMMENT '年龄',
    `pinyin`               varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '拼音码',
    `roles`                varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '角色 一对多',
    `is_system_admin`      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否系统超级管理员',
    `create_user_id`       bigint                                                                 DEFAULT NULL COMMENT '创建人',
    `pwd_salt`             varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '密码盐值',
    `login_ip`             varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '最后登录IP',
    `login_time`           datetime                                                               DEFAULT NULL COMMENT '最后登录时间',
    `login_city`           varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '最后登录城市',
    `login_province`       varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '最后登录省份',
    `login_country`        varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '最后登录国家',
    `is_remote_login`      char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '0' COMMENT '是否异地登录',
    `dept_id`              bigint                                                                 DEFAULT NULL COMMENT '部门ID',
    `dept_path`            varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '部门路径',
    `posts`                varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '岗位IDS',
    `update_time`          datetime                                                               DEFAULT NULL COMMENT '更新时间',
    `update_user_id`       bigint                                                                 DEFAULT NULL COMMENT '更新人ID',
    `last_pwd_update_time` datetime                                                               DEFAULT NULL COMMENT '最近一次密码修改时间',
    `of_module`            int                                                           NOT NULL DEFAULT '1' COMMENT '哪个模块',
    `of_module_link`       varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '具体指向关联',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='用户登录账户表';

-- ----------------------------
-- Table structure for jb_user_config
-- ----------------------------
DROP TABLE IF EXISTS `jb_user_config`;
CREATE TABLE `jb_user_config`
(
    `id`           bigint                                                        NOT NULL COMMENT '主键ID',
    `name`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置名',
    `config_key`   varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置KEY',
    `config_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci         NOT NULL COMMENT '配置值',
    `user_id`      bigint                                                        NOT NULL COMMENT '用户ID',
    `create_time`  datetime                                                     DEFAULT NULL COMMENT '创建时间',
    `update_time`  datetime                                                     DEFAULT NULL COMMENT '更新时间',
    `value_type`   varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '取值类型',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='用户系统样式自定义设置表';

-- ----------------------------
-- Table structure for jb_user_extend
-- ----------------------------
DROP TABLE IF EXISTS `jb_user_extend`;
CREATE TABLE `jb_user_extend`
(
    `id`                  bigint                                                   NOT NULL COMMENT '主键ID',
    `english_full_name`   varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '英文全名',
    `birthday`            datetime                                                          DEFAULT NULL COMMENT '出生日期',
    `residential_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '居住地址',
    `company_name`        varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '公司名称',
    `company_address`     varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '公司地址',
    `recipient_address`   varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '快递收件地址',
    `recipient_phone`     varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '收件人电话',
    `recipient_name`      varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '收件人姓名',
    `id_number`           varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '身份证号',
    `country`             varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '国家',
    `nation`              varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '民族',
    `province`            varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '省',
    `city`                varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '城市',
    `city_code`           varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '城市代码',
    `county`              varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '区县',
    `township`            varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '乡镇',
    `community`           varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '行政村 社区',
    `marital_status`      int                                                               DEFAULT NULL COMMENT '婚姻状态',
    `is_cpc_member`       char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否党员',
    `is_cyl_member`       char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否共青团员',
    `professional_title`  int                                                               DEFAULT NULL COMMENT '职称',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT ='用户扩展信息表';

-- ----------------------------
-- Table structure for jb_wechat_mpinfo
-- ----------------------------
DROP TABLE IF EXISTS `jb_wechat_mpinfo`;
CREATE TABLE `jb_wechat_mpinfo`
(
    `id`               bigint                                                   NOT NULL COMMENT '主键ID',
    `name`             varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '平台名称',
    `type`             int                                                               DEFAULT NULL COMMENT '类型 订阅号、服务号、小程序、企业号',
    `logo`             varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '头像LOGO',
    `brief_info`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '简介',
    `enable`           char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否启用',
    `is_authenticated` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否已认证',
    `subject_type`     int                                                               DEFAULT NULL COMMENT '申请认证主体的类型 个人还是企业',
    `wechat_id`        varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '微信号',
    `qrcode`           varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '二维码',
    `link_app_id`      bigint                                                            DEFAULT NULL COMMENT '关联应用ID',
    `remark`           varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '备注',
    `create_time`      datetime                                                 NOT NULL COMMENT '创建时间',
    `create_user_id`   bigint                                                   NOT NULL COMMENT '创建人',
    `update_time`      datetime                                                          DEFAULT NULL COMMENT '创建时间',
    `update_user_id`   bigint                                                            DEFAULT NULL COMMENT '更新人ID',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='微信公众平台管理';

-- ----------------------------
-- Table structure for jb_wechat_user
-- ----------------------------
DROP TABLE IF EXISTS `jb_wechat_user`;
CREATE TABLE `jb_wechat_user`
(
    `id`                 bigint                                                   NOT NULL COMMENT '主键ID',
    `nickname`           varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '用户昵称',
    `open_id`            varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT 'openId',
    `link_open_id`       int                                                               DEFAULT NULL COMMENT '关联另一个openId',
    `union_id`           varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT 'unionID',
    `sex`                int                                                               DEFAULT '0' COMMENT '性别 1男 2女 0 未知',
    `language`           varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '语言',
    `subscribe`          char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否已关注',
    `country`            varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '国家',
    `province`           varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '省',
    `city`               varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '城市',
    `head_img_url`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '头像',
    `subscribe_time`     datetime                                                          DEFAULT NULL COMMENT '关注时间',
    `remark`             varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '备注',
    `group_id`           int                                                               DEFAULT NULL COMMENT '分组',
    `tag_ids`            varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '标签',
    `subscribe_scene`    varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '关注渠道',
    `qr_scene`           int                                                               DEFAULT NULL COMMENT '二维码场景-开发者自定义',
    `qr_scene_str`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '二维码扫码场景描述-开发者自定义',
    `real_name`          varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '真实姓名',
    `phone`              varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '手机号',
    `phone_country_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      DEFAULT NULL COMMENT '手机号国家代码',
    `check_code`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '手机验证码',
    `is_checked`         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否已验证',
    `source`             int                                                               DEFAULT NULL COMMENT '来源 小程序还是公众平台',
    `session_key`        varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '小程序登录SessionKey',
    `enable`             char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '禁用访问',
    `create_time`        datetime                                                          DEFAULT NULL COMMENT '创建时间',
    `checked_time`       datetime                                                          DEFAULT NULL COMMENT '验证绑定手机号时间',
    `mp_id`              bigint                                                            DEFAULT NULL COMMENT '所属公众平台ID',
    `weixin`             varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci     DEFAULT NULL COMMENT '微信号',
    `update_time`        datetime                                                          DEFAULT NULL COMMENT '更新时间',
    `last_login_time`    datetime                                                          DEFAULT NULL COMMENT '最后登录时间',
    `first_auth_time`    datetime                                                          DEFAULT NULL COMMENT '首次授权时间',
    `last_auth_time`     datetime                                                          DEFAULT NULL COMMENT '最后一次更新授权时间',
    `first_login_time`   datetime                                                          DEFAULT NULL COMMENT '首次登录时间',
    `bind_system_user`   bigint                                                            DEFAULT NULL COMMENT '绑定系统用户',
    `bind_other`         varchar(255) COLLATE utf8mb4_general_ci                           DEFAULT NULL COMMENT '绑定其他用户信息',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='微信用户信息_模板表';

-- ----------------------------
-- Table structure for tb_demo_table
-- ----------------------------
DROP TABLE IF EXISTS `tb_demo_table`;
CREATE TABLE `tb_demo_table`
(
    `id`             bigint                                                        NOT NULL COMMENT '主键ID',
    `name`           varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  NOT NULL COMMENT '名称',
    `sn`             varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '工号',
    `title`          varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标题',
    `sex`            int                                                           NOT NULL DEFAULT '0' COMMENT '性别',
    `age`            int                                                           NOT NULL DEFAULT '0' COMMENT '年龄',
    `hobbys`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '爱好',
    `dept_id`        bigint                                                                 DEFAULT NULL COMMENT '部门',
    `posts`          varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '岗位',
    `roles`          varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '角色',
    `enable`         char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci      NOT NULL DEFAULT '1' COMMENT '是否启用',
    `start_time`     datetime                                                               DEFAULT NULL COMMENT '开始时间',
    `end_time`       datetime                                                               DEFAULT NULL COMMENT '结束时间',
    `avatar`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '头像',
    `type`           int                                                           NOT NULL DEFAULT '0' COMMENT '类型',
    `state`          int                                                           NOT NULL COMMENT '状态',
    `phone`          varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '联系电话',
    `enail`          varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '邮箱地址',
    `user_name`      varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci           DEFAULT NULL COMMENT '用户名',
    `password`       varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '密码',
    `pwd_salt`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '密码盐',
    `brief_indo`     varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci          DEFAULT NULL COMMENT '简介',
    `content`        text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '详情描述',
    `score`          decimal(10, 2)                                                         DEFAULT NULL COMMENT '积分',
    `price`          decimal(10, 2)                                                         DEFAULT NULL COMMENT '单价',
    `buy_count`      int                                                                    DEFAULT NULL COMMENT '数量',
    `amount`         decimal(10, 2)                                                         DEFAULT NULL COMMENT '总额',
    `create_time`    datetime                                                      NOT NULL COMMENT '创建时间',
    `create_user_id` bigint                                                                 DEFAULT NULL COMMENT '创建人',
    `update_time`    datetime                                                               DEFAULT NULL COMMENT '更新时间',
    `update_user_id` bigint                                                                 DEFAULT NULL COMMENT '更新人',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT ='demo测试表';

SET FOREIGN_KEY_CHECKS = 1;
